﻿CREATE TABLE [steve].[UrlRewrite] (
    [UrlRewriteId]         UNIQUEIDENTIFIER NOT NULL,
    [SiteName]             VARCHAR (50)     NOT NULL,
	[SystemName] varchar(50) null,
    [ExternalId]           VARCHAR (100)     NULL,
    [LatestRevisionNumber] INT              NOT NULL,
    [Url]                  VARCHAR (800)    NOT NULL,
	[CreateDate]			DATETIME2(7)		NOT NULL,
	[CreateMembershipId]	uniqueidentifier null
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'List of previous urls for a current site url (this is the list of 301''s)', @level0type = N'SCHEMA', @level0name = N'steve', @level1type = N'TABLE', @level1name = N'UrlRewrite';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Link to Application table', @level0type = N'SCHEMA', @level0name = N'steve', @level1type = N'TABLE', @level1name = N'UrlRewrite', @level2type = N'COLUMN', @level2name = N'SiteName';

